Conceptual Model: UML

View the conceptual model in Lucid Chart here:

https://app.lucidchart.com/invitations/accept/5602312e-dfc3-4423-975c-47190ce6022e

Conceptual UML

Logical Model: ERD

View the logical model in Lucid Chart here:

https://app.lucidchart.com/invitations/accept/7b497cbf-268d-4a03-b1a7-822b5a844fea

Logical ERD

Schema

View the schema in Google Docs here:

https://docs.google.com/document/d/1o8pk51aed3BJSaBcwO2EMbT8I3ru_wpGTcTN4W-DbIM/edit?usp=sharing

schema

Creating Database Tables

Should you wish to inspect the scripts that create the database and populate data, they can be found at:

https://github.com/eldss-classwork/databases-practicum1-scripts

The following images will show a progression from an empty database through table creation in MySQL Workbench.

The MySQL Workbench start screen.

mysql start screen

The newly created, empty test database.

mysql empty db

The test database after table creation.

mysql after creation

Populating The Database

Queries

LS0tCnRpdGxlOiAnQ1M1MjAwIEZhbGwgMjAyMDogUHJhY3RpY3VtIDEnCmF1dGhvcjogIkNoYW5kcmEgRGF2aXMsIEV2YW4gRG91Z2xhc3MiCm91dHB1dDoKICBwZGZfZG9jdW1lbnQ6IGRlZmF1bHQKICBodG1sX25vdGVib29rOiBkZWZhdWx0Ci0tLQoKIyMgQ29uY2VwdHVhbCBNb2RlbDogVU1MCgpWaWV3IHRoZSBjb25jZXB0dWFsIG1vZGVsIGluIEx1Y2lkIENoYXJ0IGhlcmU6CgpodHRwczovL2FwcC5sdWNpZGNoYXJ0LmNvbS9pbnZpdGF0aW9ucy9hY2NlcHQvNTYwMjMxMmUtZGZjMy00NDIzLTk3NWMtNDcxOTBjZTYwMjJlCgo8IS0tIEVuc3VyZSB0aGlzIGlzIHRoZSBtb3N0IHVwIHRvIGRhdGUgaW1hZ2UgLS0+CiFbQ29uY2VwdHVhbCBVTUxdKGltZ3MvQ1M1MjAwIC0gUHJhY3RpY3VtIDFfVU1MLnBuZylcCgojIyBMb2dpY2FsIE1vZGVsOiBFUkQKClZpZXcgdGhlIGxvZ2ljYWwgbW9kZWwgaW4gTHVjaWQgQ2hhcnQgaGVyZToKCmh0dHBzOi8vYXBwLmx1Y2lkY2hhcnQuY29tL2ludml0YXRpb25zL2FjY2VwdC83YjQ5N2NiZi0yNjhkLTRhMDMtYjFhNy04MjJiNWE4NDRmZWEKCjwhLS0gRW5zdXJlIHRoaXMgaXMgdGhlIG1vc3QgdXAgdG8gZGF0ZSBpbWFnZSAtLT4KIVtMb2dpY2FsIEVSRF0oaW1ncy9DUzUyMDAgLSBQcmFjdGljdW0gMV9FUkQucG5nKVwKCiMjIFNjaGVtYQoKVmlldyB0aGUgc2NoZW1hIGluIEdvb2dsZSBEb2NzIGhlcmU6CgpodHRwczovL2RvY3MuZ29vZ2xlLmNvbS9kb2N1bWVudC9kLzFvOHBrNTFhZWQzQkpTYUJjd08yRU1iVDhJM3J1X3dwR1RjVE40Vy1EYklNL2VkaXQ/dXNwPXNoYXJpbmcKCjwhLS0gRW5zdXJlIHRoaXMgaXMgdGhlIG1vc3QgdXAgdG8gZGF0ZSBpbWFnZSAtLT4KIVtzY2hlbWFdKGltZ3MvUHJhY3RpY3VtMS1TY2hlbWEucG5nKVwKCiMjIENyZWF0aW5nIERhdGFiYXNlIFRhYmxlcwoKU2hvdWxkIHlvdSB3aXNoIHRvIGluc3BlY3QgdGhlIHNjcmlwdHMgdGhhdCBjcmVhdGUgdGhlIGRhdGFiYXNlIGFuZCBwb3B1bGF0ZSBkYXRhLCB0aGV5IGNhbiBiZSBmb3VuZCBhdDoKCmh0dHBzOi8vZ2l0aHViLmNvbS9lbGRzcy1jbGFzc3dvcmsvZGF0YWJhc2VzLXByYWN0aWN1bTEtc2NyaXB0cwoKVGhlIGZvbGxvd2luZyBpbWFnZXMgd2lsbCBzaG93IGEgcHJvZ3Jlc3Npb24gZnJvbSBhbiBlbXB0eSBkYXRhYmFzZSB0aHJvdWdoIHRhYmxlIGNyZWF0aW9uIGluIE15U1FMIFdvcmtiZW5jaC4KClRoZSBNeVNRTCBXb3JrYmVuY2ggc3RhcnQgc2NyZWVuLgoKIVtteXNxbCBzdGFydCBzY3JlZW5dKGltZ3MvTXlTUUxXb3JrYmVuY2gtSW50cm9TY3JlZW4ucG5nKVwKClRoZSBuZXdseSBjcmVhdGVkLCBlbXB0eSBgdGVzdGAgZGF0YWJhc2UuCgohW215c3FsIGVtcHR5IGRiXShpbWdzL015U1FMV29ya2JlbmNoLWVtcHR5ZGIucG5nKVwKClRoZSBgdGVzdGAgZGF0YWJhc2UgYWZ0ZXIgdGFibGUgY3JlYXRpb24uCgohW215c3FsIGFmdGVyIGNyZWF0aW9uXShpbWdzL015U1FMV29ya2JlbmNoLWNyZWF0ZS5wbmcpXAoKCgojIyBQb3B1bGF0aW5nIFRoZSBEYXRhYmFzZQoKIyMgUXVlcmllcw==